Interview Questions

1. Which of the following option is true regarding a cursor?

Options:

a. A Cursor reads every row one by one.

b. They can be used to update a set of rows or a single specific row in a resultset

c. They can be positioned to specific rows.

d. Cursors lock row(s) while updating them.

Reveal Answer

2. Which of the following statement is correct?

Options:

a. A cursor cannot be used once it is deallocated

b. A cursor can be reopened any number of times after it is closed and before it is de allocated

c. The cursor is populated when FETCH attribute is used

d. All the above

Reveal Answer

3. A KEY SET driven CURSOR is not sensitive to database changes for which DML statement?

Options:

a. UPDATE

b. DELETE

c. INSERT

Reveal Answer

4. Is Dynamic Cursor sensitive to database changes

Options:

a. Yes

b. No

Reveal Answer

5. Is a Static Cursor sensitive to database changes?

Options:

a. Yes

b. No

Reveal Answer

6. What is the @@cursor_rows value declarecur_emp_9cursor static for select*fromemployee opencur_emp_9 print@@cursor_rows closecur_emp_9 deallocatecur_emp_9

Options:

a. The no:of rows in the cursor

b. -1

c. The no:0f rows in the actual table 'employee'

d. -2

Reveal Answer

7. BATCH 1: declarecur_emp13cursor local keyset for select*fromemployee opencur_emp13 print@@cursor_rows closecur_emp13 go BATCH-2: opencur_emp13 print@@cursor_rows Which statement is true for the above batches

Options:

a. Batch-1 gives the number of rows in the cursor

b. Batch-2 opens the cursor successfully as it was not deallocated and gives the number rows in the cursor

c. In Batch-2 the cursor cannot be opened as the cursor cur_emp13 doesnot exist

d. In Batch-2 the print @@cursor_rows ouput is 0

Reveal Answer

8. BATCH-1: declarecur_emp13cursor global keyset for select*fromemployee opencur_emp13 print@@cursor_rows closecur_emp13 go BATCH-2: opencur_emp13 print@@cursor_rows Which statement is true for the above batches

Options:

a. Batch-1 gives the number of rows in the cursor

b. Batch-2 opens the cursor successfully as it was not deallocated and gives the number rows in the cursor

c. In Batch-2 the cursor cannot be opened as the cursor cur_emp13 doesnot exist

d. The cursor cur_emp13 closed in session1 can be opened in another session also, as it is declared as global

Reveal Answer

9. declarecur_employeecursor dynamicoptimistic for selectempname,job,salary,fkdeptnofromemployeewheresalary>20000 forupdateofsalary,fkdeptno

Options:

a. After opening the cursor only 'job and 'empname' columns can be updated

b. After opening the cursor only 'salary' and 'fkdeptno' columns can be updated

c. After opening the cursor all the columns can be updated

d. none

Reveal Answer

10. Which of the following places lock on other users immediately?

Options:

a. OPTIMISTIC

b. SCROLL_LOCKS

Reveal Answer

11. By default sql server is in _______________

Options:

a. Explicit transaction

b. Auto-commit transaction

c. Implicit transaction

Reveal Answer

12. The Explicit transactions can be done when the sql server is in

Options:

a. Implicit transactions

b. Auto-commit transaction

c. Both

d. None of the two transactions

Reveal Answer

13. ____________ cursor is sensitive to any changes to the data source

Options:

a. Static Cursors

b. Dynamic Cursors

c. Keyset Driven Cursors

d. None of the mentioned

Reveal Answer

14. A dynamic cursor in SQL Server allows you to see ________ data.

Options:

a. Updated

b. Inserted

c. Deleted

d. All of the mentioned

Reveal Answer

15. How many types of cursor is present in SQL Server ?

Options:

a. 3

b. 4

c. 5

d. 6

Reveal Answer

16. Point out the correct statement :

Options:

a. A Cursor is opened and populated by executing the SQL statement defined by the cursor

b. After data manipulation, we should close the cursor explicitly

c. A cursor is declared by defining the SQL statement that returns a result set

d. All of the mentioned

Reveal Answer

17. Various alternatives to cursor in SQL Server are :

Options:

a. FOR

b. IF..ELSE

c. WHILE

d. All of the mentioned

Reveal Answer

Interview Questions and Answer

1. Which of the following option is true regarding a cursor?

2. Which of the following statement is correct?

3. A KEY SET driven CURSOR is not sensitive to database changes for which DML statement?

4. Is Dynamic Cursor sensitive to database changes

5. Is a Static Cursor sensitive to database changes?

6. What is the @@cursor_rows value declarecur_emp_9cursor static for select*fromemployee opencur_emp_9 print@@cursor_rows closecur_emp_9 deallocatecur_emp_9

7. BATCH 1: declarecur_emp13cursor local keyset for select*fromemployee opencur_emp13 print@@cursor_rows closecur_emp13 go BATCH-2: opencur_emp13 print@@cursor_rows Which statement is true for the above batches

8. BATCH-1: declarecur_emp13cursor global keyset for select*fromemployee opencur_emp13 print@@cursor_rows closecur_emp13 go BATCH-2: opencur_emp13 print@@cursor_rows Which statement is true for the above batches

9. declarecur_employeecursor dynamicoptimistic for selectempname,job,salary,fkdeptnofromemployeewheresalary>20000 forupdateofsalary,fkdeptno

10. Which of the following places lock on other users immediately?

11. By default sql server is in _______________

12. The Explicit transactions can be done when the sql server is in

13. ____________ cursor is sensitive to any changes to the data source

14. A dynamic cursor in SQL Server allows you to see ________ data.

15. How many types of cursor is present in SQL Server ?

16. Point out the correct statement :

17. Various alternatives to cursor in SQL Server are :

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources